<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Log uitgevoerde SQL commando's in MySQL/MariaDB</title>
        <link rel="stylesheet" type="text/css" href="./css/markdown.css" />
    </head>
    <body>

    <div id="navigation">
    <a href="https://www.iredmail.org" target="_blank">
        <img alt="iRedMail web site"
             src="./images/logo-iredmail.png"
             style="vertical-align: middle; height: 30px;"
             />&nbsp;
        <span>iRedMail</span>
    </a>
    &nbsp;&nbsp;//&nbsp;&nbsp;<a href="./index.html">Document Index</a></div><div class="admonition note">
<p class="admonition-title">This tutorial is available in other languages. <a href="https://github.com/iredmail/docs">Help translate more</a></p>
<p><a href="./debug.mysql.html">English</a> /</p>
</div>
<h1 id="log-uitgevoerde-sql-commandos-in-mysqlmariadb">Log uitgevoerde SQL commando's in MySQL/MariaDB</h1>
<blockquote>
<p>Weet je niet waar het MySQL configuratiebestand zich bevindt? Check deze tutorial:
<a href="file.locations.html#mysql-mariadb">Locaties van configuratie and log bestanden van belangrijke componenten</a>.</p>
</blockquote>
<p>Om uitgevoerde SQL commando's te loggen moet je onderstaande instellingen toevoegen aan MySQL/MariaDB configuratiebestand <code>my.cnf</code>:</p>
<pre><code>[mysqld]
general_log = 1
general_log_file = /var/log/mysql.log
</code></pre>
<p>Dan MySQL/MariaDB service herstarten.</p>
<p>Merk op: MySQL/MariaDB daemon gebruiker moet de bemachtigingen hebben om te kunnen schrijven naar dit logbestand.</p><div class="footer">
    <p style="text-align: center; color: grey;">All documents are available in <a href="https://github.com/iredmail/docs/">GitHub repository</a>, and published under <a href="http://creativecommons.org/licenses/by-nd/3.0/us/" target="_blank">Creative Commons</a> license. You can <a href="https://github.com/iredmail/docs/archive/master.zip">download the latest version</a> for offline reading. If you found something wrong, please do <a href="https://www.iredmail.org/contact.html">contact us</a> to fix it.</p>
</div></body></html>